﻿IF object_id(N'dbo.TabExtMailLog', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[TabExtMailLog] (
        [LogID]      numeric(18,0) NOT NULL identity(1, 1),
        [UserID]     numeric(18,0) NOT NULL,
        [LogData]    datetime      NOT NULL,
        [LogMessage] nvarchar(500) COLLATE Chinese_PRC_CI_AS NOT NULL,

        CONSTRAINT [PK_TabMailLog] PRIMARY KEY CLUSTERED ([LogID] asc),
        CONSTRAINT [FK_TabMailLog_TabUser] FOREIGN KEY ([UserID]) REFERENCES [dbo].[TabAccountIndex] ([UserID]) ON DELETE CASCADE ON UPDATE CASCADE
    );
END
GO
